﻿<?xml version="1.0" encoding="utf-8"?>
<clientTestSessionDescriptor>
    <clientSession id="c5bc0460-75d4-4de8-af18-d87cb4a70c62" testServerId="16eaa41e-e9da-4a2b-8a92-767bd2cca9fa" testSessionId="44accb76-49cc-4b14-baf0-34635fd6f5ea">
        <enableLog value="false" />
        <orchestratorEndPointBinding>
            <binding>netTcpBinding</binding>
            <address>net.tcp://Orchestrator1/zen4sync</address>
        </orchestratorEndPointBinding>
        <scheduledStartDateTime>2011-05-11T09:20:00Z</scheduledStartDateTime>

        <testScenario id="b80f5358-c44f-4a2b-a2bd-bad5f79b5a0e">

            <activity id="aac891bb-0f67-4b55-b108-37985e4dfb8d">
                <executionOrder>1</executionOrder>
                <preWaitingTimeInSeconds>0</preWaitingTimeInSeconds>
                <postWaitingTimeInSeconds>0</postWaitingTimeInSeconds>

                <activityItem type="SqlServerExecution">
                    <sqlServerExecution id="228f7430-4f5a-4436-a7e9-a31671128944">
                        <sqlQuery>
                            <![CDATA[UPDATE Customer SET c_name = @Name WHERE c_id = @Id]]>
                        </sqlQuery>
                    </sqlServerExecution>
                </activityItem>
                <activityContext id="5792a878-99a9-45c2-a7e2-746b30aa89c8">
                    <sqlServerExecutionContext id="d49b1001-b88b-4c25-b8d5-dc5539cf7d2f">
                        <connectionString>Server=localhost\SQL2008R2;Database=Zen4SyncTestBusiness; Trusted_Connection=yes;</connectionString>
                        <sqlQueryParameters count="2">
                            <parameter name="@Name" type="Nvarchar"><![CDATA[Bob2]]></parameter>
                            <parameter name="@Id" type="UniqueIdentifier"><![CDATA[EC031307-41E6-435F-A058-FC1BC867B61E]]></parameter>
                        </sqlQueryParameters>
                    </sqlServerExecutionContext>
                </activityContext>
            </activity>

            <activity id="e029fe03-8d5c-480c-af46-c499ff8299a5">
                <executionOrder>2</executionOrder>
                <preWaitingTimeInSeconds>0</preWaitingTimeInSeconds>
                <postWaitingTimeInSeconds>0</postWaitingTimeInSeconds>

                <activityItem type="SqlServerCheckData">
                    <sqlServerCheckData id="102d3cbc-992b-4737-8a1f-4363cccd6192">
                        <sqlQuery><![CDATA[SELECT c_inscriptionDate FROM Customer WHERE c_id = @Id ;]]>
                        </sqlQuery>
                        <expectedValue type="DateTime"><![CDATA[25/01/2009 09:55]]></expectedValue>
                    </sqlServerCheckData>
                </activityItem>
                <activityContext id="33717460-7b3f-4100-81aa-cf46f2e3f7bb">
                    <sqlServerCheckDataContext id="4a4e6bc4-601a-49c9-a637-b8e42b55338b">
                        <connectionString>Server=localhost\SQL2008R2;Database=Zen4SyncTestBusiness; Trusted_Connection=yes;</connectionString>
                        <sqlQueryParameters count="1">
                            <parameter name="@Id" type="UniqueIdentifier"><![CDATA[EC031307-41E6-435F-A058-FC1BC867B61E]]></parameter>
                        </sqlQueryParameters>
                    </sqlServerCheckDataContext>
                </activityContext>
            </activity>


        </testScenario>
    </clientSession>
</clientTestSessionDescriptor>